﻿
CREATE PROCEDURE [svc].[GetAllSessionLogsByCpuTimeFilter]
(
	@FromDate				datetime,
	@ToDate					datetime, 
	@CpuTimeFilter			int
)
AS
BEGIN

SELECT Id, InstanceName, DatabaseName, CpuTime, LastModifiedDate FROM dbo.ExecSessionLog 
WHERE LastModifiedDate BETWEEN @FromDate AND @ToDate 
AND CpuTime > @CpuTimeFilter 
ORDER BY InstanceName

END